25. Solutions: WHERE

Solution from previous WHERE Questions

  1. SELECT *
FROM orders
WHERE gloss_amt_usd >= 1000
LIMIT 5;
    2. 2. 
SELECT *
FROM orders
WHERE total_amt_usd < 500
LIMIT 10;

You will notice when using these WHERE statements, we do not need to ORDER BY unless we want to actually order our data. Our condition will work without having to do any sorting of the data.

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity, so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept